package models

const PERSON = "" +
	"CREATE TABLE IF NOT EXISTS `person` (\n" +
	"	`person_id`	INTEGER NOT NULL PRIMARY KEY AUTOINCREMENT UNIQUE,\n" +
	"	`person_name`	TEXT,\n" +
	"	`face_person_id`	TEXT,\n" +
	"	`create_time`	INTEGER NOT NULL,\n" +
	"	`last_time`	INTEGER ,\n" +
	"	`count`	INTEGER ,\n" +
	"	`attribute`	INTEGER NOT NULL,\n" +
	"	`command`	TEXT\n" +
	");"

const FACE = "" +
	"CREATE TABLE IF NOT EXISTS `face` (\n" +
	"	`face_id`	INTEGER NOT NULL UNIQUE,\n" +
	"	`face_url`	TEXT NOT NULL,\n" +
	"	`face_add_id`	TEXT NOT NULL,\n" +
	"	`img_id`	TEXT NOT NULL,\n" +
	"	`person_id`	INTEGER ,\n" +
	"	`create_time`	INTEGER ,\n" +
	"	PRIMARY KEY(face_id)\n" +
	");"
